{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "shtSrc= pd.read_excel(\"Fusion.xlsx\", sheet_name = 0,skiprows=3,skipfooter=1)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Item ID</th>\n",
       "      <th>Feature ID</th>\n",
       "      <th>Summary</th>\n",
       "      <th>Issue Type</th>\n",
       "      <th>Key</th>\n",
       "      <th>Competence Area</th>\n",
       "      <th>Start FB</th>\n",
       "      <th>End FB</th>\n",
       "      <th>FB Committed Status</th>\n",
       "      <th>Σ Original Estimate</th>\n",
       "      <th>Σ Logged Effort</th>\n",
       "      <th>Σ Remaining Estimate</th>\n",
       "      <th>Assignee</th>\n",
       "      <th>Reporter</th>\n",
       "      <th>Planned System Release</th>\n",
       "      <th>Parent Link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>5GC000704-G-a1</td>\n",
       "      <td>5GC000704</td>\n",
       "      <td>5GC000704-G-a1 : Handling of concurrency betwe...</td>\n",
       "      <td>Competence Area</td>\n",
       "      <td>FPB-318340</td>\n",
       "      <td>ECE C-Plane NRT</td>\n",
       "      <td>1906</td>\n",
       "      <td>1906</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1080000</td>\n",
       "      <td>0h</td>\n",
       "      <td>1080000</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>FPB-3183345GC000704-G-a : Handling of concurre...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>5GC000704-G-b1</td>\n",
       "      <td>5GC000704</td>\n",
       "      <td>5GC000704-G-b1 : Handling of concurrency betwe...</td>\n",
       "      <td>Competence Area</td>\n",
       "      <td>FPB-318341</td>\n",
       "      <td>ECE C-Plane NRT</td>\n",
       "      <td>1907</td>\n",
       "      <td>1907</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2160000</td>\n",
       "      <td>0h</td>\n",
       "      <td>2160000</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>FPB-3183355GC000704-G-b : Handling of concurre...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>5GC000704-G-c1</td>\n",
       "      <td>5GC000704</td>\n",
       "      <td>5GC000704-G-c1 : Handling of concurrency betwe...</td>\n",
       "      <td>Competence Area</td>\n",
       "      <td>FPB-318342</td>\n",
       "      <td>ECE C-Plane NRT</td>\n",
       "      <td>1907</td>\n",
       "      <td>1908</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2160000</td>\n",
       "      <td>0h</td>\n",
       "      <td>2160000</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>FPB-3183365GC000704-G-c : Handling of concurre...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>5GC000733-F-A-a4</td>\n",
       "      <td>5GC000733</td>\n",
       "      <td>5GC000733-F-A-a4: Idle paging - Updation of TA...</td>\n",
       "      <td>Competence Area</td>\n",
       "      <td>FPB-278811</td>\n",
       "      <td>ECE C-Plane NRT</td>\n",
       "      <td>1903</td>\n",
       "      <td>1903</td>\n",
       "      <td>Committed</td>\n",
       "      <td>108000</td>\n",
       "      <td>30h</td>\n",
       "      <td>0</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>Kumar, Ajay B. (Nokia - IN/Bangalore)</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>FPB-2788075GC000733-F: Idle paging</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5GC000733-F-a16</td>\n",
       "      <td>5GC000733</td>\n",
       "      <td>5GC000733-F-a16: Updation TAC to 5G-CP-CELL in...</td>\n",
       "      <td>Competence Area</td>\n",
       "      <td>FPB-292620</td>\n",
       "      <td>ECE C-Plane NRT</td>\n",
       "      <td>1903</td>\n",
       "      <td>1903</td>\n",
       "      <td>Committed</td>\n",
       "      <td>144000</td>\n",
       "      <td>40h</td>\n",
       "      <td>0</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>Dsouza, Allan (Nokia - IN/Bangalore)</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>FPB-2788075GC000733-F: Idle paging</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Item ID Feature ID  \\\n",
       "0    5GC000704-G-a1  5GC000704   \n",
       "1    5GC000704-G-b1  5GC000704   \n",
       "2    5GC000704-G-c1  5GC000704   \n",
       "3  5GC000733-F-A-a4  5GC000733   \n",
       "4   5GC000733-F-a16  5GC000733   \n",
       "\n",
       "                                             Summary       Issue Type  \\\n",
       "0  5GC000704-G-a1 : Handling of concurrency betwe...  Competence Area   \n",
       "1  5GC000704-G-b1 : Handling of concurrency betwe...  Competence Area   \n",
       "2  5GC000704-G-c1 : Handling of concurrency betwe...  Competence Area   \n",
       "3  5GC000733-F-A-a4: Idle paging - Updation of TA...  Competence Area   \n",
       "4  5GC000733-F-a16: Updation TAC to 5G-CP-CELL in...  Competence Area   \n",
       "\n",
       "          Key  Competence Area  Start FB  End FB FB Committed Status  \\\n",
       "0  FPB-318340  ECE C-Plane NRT      1906    1906                 NaN   \n",
       "1  FPB-318341  ECE C-Plane NRT      1907    1907                 NaN   \n",
       "2  FPB-318342  ECE C-Plane NRT      1907    1908                 NaN   \n",
       "3  FPB-278811  ECE C-Plane NRT      1903    1903           Committed   \n",
       "4  FPB-292620  ECE C-Plane NRT      1903    1903           Committed   \n",
       "\n",
       "   Σ Original Estimate Σ Logged Effort  Σ Remaining Estimate  \\\n",
       "0              1080000              0h               1080000   \n",
       "1              2160000              0h               2160000   \n",
       "2              2160000              0h               2160000   \n",
       "3               108000             30h                     0   \n",
       "4               144000             40h                     0   \n",
       "\n",
       "                             Assignee                               Reporter  \\\n",
       "0  Du, Jianjun B. (NSB - CN/Shanghai)     Du, Jianjun B. (NSB - CN/Shanghai)   \n",
       "1  Du, Jianjun B. (NSB - CN/Shanghai)     Du, Jianjun B. (NSB - CN/Shanghai)   \n",
       "2  Du, Jianjun B. (NSB - CN/Shanghai)     Du, Jianjun B. (NSB - CN/Shanghai)   \n",
       "3  Du, Jianjun B. (NSB - CN/Shanghai)  Kumar, Ajay B. (Nokia - IN/Bangalore)   \n",
       "4  Du, Jianjun B. (NSB - CN/Shanghai)   Dsouza, Allan (Nokia - IN/Bangalore)   \n",
       "\n",
       "  Planned System Release                                        Parent Link  \n",
       "0                  5G19B  FPB-3183345GC000704-G-a : Handling of concurre...  \n",
       "1                  5G19B  FPB-3183355GC000704-G-b : Handling of concurre...  \n",
       "2                  5G19B  FPB-3183365GC000704-G-c : Handling of concurre...  \n",
       "3                  5G19B                 FPB-2788075GC000733-F: Idle paging  \n",
       "4                  5G19B                 FPB-2788075GC000733-F: Idle paging  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "shtSrc.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Item ID</th>\n",
       "      <th>Feature ID</th>\n",
       "      <th>Planned System Release</th>\n",
       "      <th>Summary</th>\n",
       "      <th>FB Committed Status</th>\n",
       "      <th>End FB</th>\n",
       "      <th>Start FB</th>\n",
       "      <th>Σ Remaining Estimate</th>\n",
       "      <th>Σ Logged Effort</th>\n",
       "      <th>Σ Original Estimate</th>\n",
       "      <th>...</th>\n",
       "      <th>1909</th>\n",
       "      <th>1909.1</th>\n",
       "      <th>1910</th>\n",
       "      <th>1910.1</th>\n",
       "      <th>1911</th>\n",
       "      <th>1911.1</th>\n",
       "      <th>1912</th>\n",
       "      <th>1912.1</th>\n",
       "      <th>1913</th>\n",
       "      <th>1913.1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>ECERD-3981</td>\n",
       "      <td>ECERD-3981</td>\n",
       "      <td>5G19A</td>\n",
       "      <td>CP-NRT_trbl_log_list.csv is missing</td>\n",
       "      <td>Plan</td>\n",
       "      <td>1904.0</td>\n",
       "      <td>1904.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>ECERD-4136</td>\n",
       "      <td>ECERD-4136</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>ECERD-4136 Uncaught/improper exception causing...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1905.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>5GC000733-Q-B-a1</td>\n",
       "      <td>5GC000733</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>5GC000733-Q-B-a1: Idle Paging Error Handling -...</td>\n",
       "      <td>Committed</td>\n",
       "      <td>1906.0</td>\n",
       "      <td>1906.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>0h</td>\n",
       "      <td>160.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5GC000733-Q-B-a2</td>\n",
       "      <td>5GC000733</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>5GC000733-Q-B-a2: Idle Paging Error Handling - F1</td>\n",
       "      <td>Committed</td>\n",
       "      <td>1906.0</td>\n",
       "      <td>1906.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>0h</td>\n",
       "      <td>160.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Item ID  Feature ID Planned System Release  \\\n",
       "0        ECERD-3981  ECERD-3981                  5G19A   \n",
       "1        ECERD-4136  ECERD-4136                  5G19B   \n",
       "2               NaN         NaN                    NaN   \n",
       "3  5GC000733-Q-B-a1   5GC000733                  5G19B   \n",
       "4  5GC000733-Q-B-a2   5GC000733                  5G19B   \n",
       "\n",
       "                                             Summary FB Committed Status  \\\n",
       "0                CP-NRT_trbl_log_list.csv is missing                Plan   \n",
       "1  ECERD-4136 Uncaught/improper exception causing...                 NaN   \n",
       "2                                                NaN                 NaN   \n",
       "3  5GC000733-Q-B-a1: Idle Paging Error Handling -...           Committed   \n",
       "4  5GC000733-Q-B-a2: Idle Paging Error Handling - F1           Committed   \n",
       "\n",
       "   End FB  Start FB  Σ Remaining Estimate Σ Logged Effort  \\\n",
       "0  1904.0    1904.0                   NaN             NaN   \n",
       "1  1905.0       NaN                   NaN             NaN   \n",
       "2     NaN       NaN                   NaN             NaN   \n",
       "3  1906.0    1906.0                 160.0              0h   \n",
       "4  1906.0    1906.0                 160.0              0h   \n",
       "\n",
       "   Σ Original Estimate  ... 1909 1909.1  1910 1910.1 1911 1911.1 1912 1912.1  \\\n",
       "0                  NaN  ...  NaN    NaN   NaN    NaN  NaN    NaN  NaN    NaN   \n",
       "1                  NaN  ...  NaN    NaN   NaN    NaN  NaN    NaN  NaN    NaN   \n",
       "2                  NaN  ...  NaN    NaN   NaN    NaN  NaN    NaN  NaN    NaN   \n",
       "3                160.0  ...  NaN    NaN   NaN    NaN  NaN    NaN  NaN    NaN   \n",
       "4                160.0  ...  NaN    NaN   NaN    NaN  NaN    NaN  NaN    NaN   \n",
       "\n",
       "  1913  1913.1  \n",
       "0  NaN     NaN  \n",
       "1  NaN     NaN  \n",
       "2  NaN     NaN  \n",
       "3  NaN     NaN  \n",
       "4  NaN     NaN  \n",
       "\n",
       "[5 rows x 48 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "shtTgt = pd.read_excel(\"5G_Feature_Planning.xlsx\",sheet_name=\"Feature Plan\", skiprows = 1)\n",
    "shtTgt.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'merge' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-4-1a1bd3bd9e94>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mmerge\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mshtSrc\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mshtTgt\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m: name 'merge' is not defined"
     ]
    }
   ],
   "source": [
    "merge(shtSrc, shtTgt)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Item ID</th>\n",
       "      <th>Feature ID</th>\n",
       "      <th>Summary</th>\n",
       "      <th>Issue Type</th>\n",
       "      <th>Key</th>\n",
       "      <th>Competence Area</th>\n",
       "      <th>Start FB</th>\n",
       "      <th>End FB</th>\n",
       "      <th>FB Committed Status</th>\n",
       "      <th>Σ Original Estimate</th>\n",
       "      <th>...</th>\n",
       "      <th>1909</th>\n",
       "      <th>1909.1</th>\n",
       "      <th>1910</th>\n",
       "      <th>1910.1</th>\n",
       "      <th>1911</th>\n",
       "      <th>1911.1</th>\n",
       "      <th>1912</th>\n",
       "      <th>1912.1</th>\n",
       "      <th>1913</th>\n",
       "      <th>1913.1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>0 rows × 54 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Item ID, Feature ID, Summary, Issue Type, Key, Competence Area, Start FB, End FB, FB Committed Status, Σ Original Estimate, Σ Logged Effort, Σ Remaining Estimate, Assignee, Reporter, Planned System Release, Parent Link, Team, FB Plan Status, FB Plan FB , Hightlights, Status \n",
       "Current Sprint \n",
       ", Status \n",
       "Last Sprint \n",
       ", LE \n",
       "Sprint, Start \n",
       "Sprint, End \n",
       "Sprint, Remaining Effort \n",
       "WH, Story Points, TOTAL, 1901, 1901.1, 1902, 1902.1, 1903, 1903.1, 1904, 1904.1, 1905, 1905.1, 1906, 1906.1, 1907, 1907.1, 1908, 1908.1, 1909, 1909.1, 1910, 1910.1, 1911, 1911.1, 1912, 1912.1, 1913, 1913.1]\n",
       "Index: []\n",
       "\n",
       "[0 rows x 54 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.merge(shtSrc, shtTgt)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Item ID', 'Feature ID', 'Summary', 'Issue Type', 'Key',\n",
       "       'Competence Area', 'Start FB', 'End FB', 'FB Committed Status',\n",
       "       'Σ Original Estimate', 'Σ Logged Effort', 'Σ Remaining Estimate',\n",
       "       'Assignee', 'Reporter', 'Planned System Release', 'Parent Link'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "shtSrc.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([                   'Item ID',                 'Feature ID',\n",
       "           'Planned System Release',                    'Summary',\n",
       "              'FB Committed Status',                     'End FB',\n",
       "                         'Start FB',       'Σ Remaining Estimate',\n",
       "                  'Σ Logged Effort',        'Σ Original Estimate',\n",
       "                             'Team',             'FB Plan Status',\n",
       "                      'FB Plan FB ',                'Hightlights',\n",
       "       'Status \\nCurrent Sprint \\n',    'Status \\nLast Sprint \\n',\n",
       "                      'LE \\nSprint',             'Start \\nSprint',\n",
       "                     'End \\nSprint',      'Remaining Effort \\nWH',\n",
       "                     'Story Points',                      'TOTAL',\n",
       "                               1901,                     '1901.1',\n",
       "                               1902,                     '1902.1',\n",
       "                               1903,                     '1903.1',\n",
       "                               1904,                     '1904.1',\n",
       "                               1905,                     '1905.1',\n",
       "                               1906,                     '1906.1',\n",
       "                               1907,                     '1907.1',\n",
       "                               1908,                     '1908.1',\n",
       "                               1909,                     '1909.1',\n",
       "                               1910,                     '1910.1',\n",
       "                               1911,                     '1911.1',\n",
       "                               1912,                     '1912.1',\n",
       "                               1913,                     '1913.1'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "shtTgt.keys()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Item ID</th>\n",
       "      <th>Feature ID_x</th>\n",
       "      <th>Summary_x</th>\n",
       "      <th>Issue Type</th>\n",
       "      <th>Key</th>\n",
       "      <th>Competence Area</th>\n",
       "      <th>Start FB_x</th>\n",
       "      <th>End FB_x</th>\n",
       "      <th>FB Committed Status_x</th>\n",
       "      <th>Σ Original Estimate_x</th>\n",
       "      <th>...</th>\n",
       "      <th>1909</th>\n",
       "      <th>1909.1</th>\n",
       "      <th>1910</th>\n",
       "      <th>1910.1</th>\n",
       "      <th>1911</th>\n",
       "      <th>1911.1</th>\n",
       "      <th>1912</th>\n",
       "      <th>1912.1</th>\n",
       "      <th>1913</th>\n",
       "      <th>1913.1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>5GC000704-G-a1</td>\n",
       "      <td>5GC000704</td>\n",
       "      <td>5GC000704-G-a1 : Handling of concurrency betwe...</td>\n",
       "      <td>Competence Area</td>\n",
       "      <td>FPB-318340</td>\n",
       "      <td>ECE C-Plane NRT</td>\n",
       "      <td>1906.0</td>\n",
       "      <td>1906.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1080000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>5GC000704-G-b1</td>\n",
       "      <td>5GC000704</td>\n",
       "      <td>5GC000704-G-b1 : Handling of concurrency betwe...</td>\n",
       "      <td>Competence Area</td>\n",
       "      <td>FPB-318341</td>\n",
       "      <td>ECE C-Plane NRT</td>\n",
       "      <td>1907.0</td>\n",
       "      <td>1907.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2160000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>5GC000704-G-c1</td>\n",
       "      <td>5GC000704</td>\n",
       "      <td>5GC000704-G-c1 : Handling of concurrency betwe...</td>\n",
       "      <td>Competence Area</td>\n",
       "      <td>FPB-318342</td>\n",
       "      <td>ECE C-Plane NRT</td>\n",
       "      <td>1907.0</td>\n",
       "      <td>1908.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2160000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>5GC000733-F-A-a4</td>\n",
       "      <td>5GC000733</td>\n",
       "      <td>5GC000733-F-A-a4: Idle paging - Updation of TA...</td>\n",
       "      <td>Competence Area</td>\n",
       "      <td>FPB-278811</td>\n",
       "      <td>ECE C-Plane NRT</td>\n",
       "      <td>1903.0</td>\n",
       "      <td>1903.0</td>\n",
       "      <td>Committed</td>\n",
       "      <td>108000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5GC000733-F-a16</td>\n",
       "      <td>5GC000733</td>\n",
       "      <td>5GC000733-F-a16: Updation TAC to 5G-CP-CELL in...</td>\n",
       "      <td>Competence Area</td>\n",
       "      <td>FPB-292620</td>\n",
       "      <td>ECE C-Plane NRT</td>\n",
       "      <td>1903.0</td>\n",
       "      <td>1903.0</td>\n",
       "      <td>Committed</td>\n",
       "      <td>144000.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>101</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>102</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>103</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>104</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>105</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>106 rows × 63 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Item ID Feature ID_x  \\\n",
       "0      5GC000704-G-a1    5GC000704   \n",
       "1      5GC000704-G-b1    5GC000704   \n",
       "2      5GC000704-G-c1    5GC000704   \n",
       "3    5GC000733-F-A-a4    5GC000733   \n",
       "4     5GC000733-F-a16    5GC000733   \n",
       "..                ...          ...   \n",
       "101               NaN          NaN   \n",
       "102               NaN          NaN   \n",
       "103               NaN          NaN   \n",
       "104               NaN          NaN   \n",
       "105               NaN          NaN   \n",
       "\n",
       "                                             Summary_x       Issue Type  \\\n",
       "0    5GC000704-G-a1 : Handling of concurrency betwe...  Competence Area   \n",
       "1    5GC000704-G-b1 : Handling of concurrency betwe...  Competence Area   \n",
       "2    5GC000704-G-c1 : Handling of concurrency betwe...  Competence Area   \n",
       "3    5GC000733-F-A-a4: Idle paging - Updation of TA...  Competence Area   \n",
       "4    5GC000733-F-a16: Updation TAC to 5G-CP-CELL in...  Competence Area   \n",
       "..                                                 ...              ...   \n",
       "101                                                NaN              NaN   \n",
       "102                                                NaN              NaN   \n",
       "103                                                NaN              NaN   \n",
       "104                                                NaN              NaN   \n",
       "105                                                NaN              NaN   \n",
       "\n",
       "            Key  Competence Area  Start FB_x  End FB_x FB Committed Status_x  \\\n",
       "0    FPB-318340  ECE C-Plane NRT      1906.0    1906.0                   NaN   \n",
       "1    FPB-318341  ECE C-Plane NRT      1907.0    1907.0                   NaN   \n",
       "2    FPB-318342  ECE C-Plane NRT      1907.0    1908.0                   NaN   \n",
       "3    FPB-278811  ECE C-Plane NRT      1903.0    1903.0             Committed   \n",
       "4    FPB-292620  ECE C-Plane NRT      1903.0    1903.0             Committed   \n",
       "..          ...              ...         ...       ...                   ...   \n",
       "101         NaN              NaN         NaN       NaN                   NaN   \n",
       "102         NaN              NaN         NaN       NaN                   NaN   \n",
       "103         NaN              NaN         NaN       NaN                   NaN   \n",
       "104         NaN              NaN         NaN       NaN                   NaN   \n",
       "105         NaN              NaN         NaN       NaN                   NaN   \n",
       "\n",
       "     Σ Original Estimate_x  ... 1909  1909.1 1910 1910.1 1911 1911.1 1912  \\\n",
       "0                1080000.0  ...  NaN     NaN  NaN    NaN  NaN    NaN  NaN   \n",
       "1                2160000.0  ...  NaN     NaN  NaN    NaN  NaN    NaN  NaN   \n",
       "2                2160000.0  ...  NaN     NaN  NaN    NaN  NaN    NaN  NaN   \n",
       "3                 108000.0  ...  NaN     NaN  NaN    NaN  NaN    NaN  NaN   \n",
       "4                 144000.0  ...  NaN     NaN  NaN    NaN  NaN    NaN  NaN   \n",
       "..                     ...  ...  ...     ...  ...    ...  ...    ...  ...   \n",
       "101                    NaN  ...  NaN     NaN  NaN    NaN  NaN    NaN  NaN   \n",
       "102                    NaN  ...  NaN     NaN  NaN    NaN  NaN    NaN  NaN   \n",
       "103                    NaN  ...  NaN     NaN  NaN    NaN  NaN    NaN  NaN   \n",
       "104                    NaN  ...  NaN     NaN  NaN    NaN  NaN    NaN  NaN   \n",
       "105                    NaN  ...  NaN     NaN  NaN    NaN  NaN    NaN  NaN   \n",
       "\n",
       "    1912.1 1913 1913.1  \n",
       "0      NaN  NaN    NaN  \n",
       "1      NaN  NaN    NaN  \n",
       "2      NaN  NaN    NaN  \n",
       "3      NaN  NaN    NaN  \n",
       "4      NaN  NaN    NaN  \n",
       "..     ...  ...    ...  \n",
       "101    NaN  NaN    NaN  \n",
       "102    NaN  NaN    NaN  \n",
       "103    NaN  NaN    NaN  \n",
       "104    NaN  NaN    NaN  \n",
       "105    NaN  NaN    NaN  \n",
       "\n",
       "[106 rows x 63 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.merge(shtSrc, shtTgt,how='right', on=['Item ID'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
